Doing Data Science - Project 1

Map A - Breweries by State

In contrast to the breweries per state in the map above, the Beers by State is another good way to review the data. While Florida doesn’t have many local breweries as mentioned above, it has a lot of beers in the state and it might be a good location for the next brewery because Florida is a state that does drink a lot of different types of beer. However, additional testing will be needed, but a good target for a location.

Map B - Beers by State

As you continue to do the exploratory research, we implemented an interactive matrix will outline the number of Beers produced by each state. There are very good targets to do further investigation for your next location. This matrix will help guide you to next hot market as you begin to understand what beers and breweries work in which geography across the US.

Table A

Table B

As a item to pay attention as you begin to look through the analysis, it is essential to not just look at the raw numbers, but rather understand and realize that there are fields in the data set that have invalid or N/A columns. As you work with your data science teams, they will be critical as you being the basic regression testing because these type of data irregularities can cause data integrity issues within results. The table below is meant to be a quick summary of the columns that have invalid or N/A Columns

Table C

As we begin analyzing the data in the brewery’s and types of beer, two important factors need to be understood and analyzed. Median Alcohol by Volume (ABV) and International Bitterness Units (IBU) are essential in understanding what factors are important in each states. For example, the beer drinkers in Alaska like bitter beer (IBU = 46) as compared to Arizona (IBU = 20.5). While reviewing this is a matrix is difficult, the data science team can use this data and decorate with other variables are you begin developing and marketing your new beer and or brewery.

Table D

While it is important to understand the raw data, this bar chart will allow you to quickly decipher which states prefer which Beer IBU.

Table E

Just as important as the IBU scale, the following ABV bar chart will allow you to quickly decipher which states prefer which Beer ABV

Table F

Alcohol by Volume Chart

Another good example of how you can utilize the data set to your competitive advantage is understanding which State has the Maximum ABV and which states has the most bitter Beer. The following table outlines the top state that has the IBU and ABV.

Table G

As we look into the statistics of the Alcohol by Volume in Table H, the data shows that the Mean ABV is almost 6% but is as high as 10% and as low at 0.1%.

Table H

Based on the data set, there is a positive correlation and a linear relationship between IBU and ABV, as seen in Table I. As the ABV increases, so does the IBU. This is essential in your creation of a brewery and new beers to understand that this is a standard relationship in these two variables.

Table I

In our box and whisker plot in Table K, this is another way to analyze the beers per state. The competitive intelligence that can be gained is the typical sweet spot, median and mean, for where the majority of the beers are being produced by that state based on IBU and ABV. Depending on the appetite, staying in this range is a strategic decision in how your build breweries or formulate the beer.

Table K